package cn.net.shuxing.yifu.common.mapper;


import cn.net.shuxing.yifu.common.bean.UserCashHistory;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public interface UserCashHistoryMapper extends Mapper<UserCashHistory> {


    @Select("SELECT\n" +
            "*\n" +
            "FROM\n" +
            "\tuser_cash_history\n" +
            "WHERE\n" +
            "(type = 13 OR type = 16 OR type = 17)\n" +
            "AND (deleted = 0)" +
            "ORDER BY create_time DESC")
    public List<UserCashHistory> getSysCashier();

    @Select("SELECT\n" +
            "*\n" +
            "FROM\n" +
            "\tuser_cash_history\n" +
            "WHERE\n" +
            "(type = 14 OR type = 18)\n" +
            "AND (deleted = 0)" +
            "ORDER BY create_time DESC")
    public List<UserCashHistory> getSysPay();
}

